﻿CREATE TABLE [dbo].[Project] (
    [Id]                 UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [Name]               NVARCHAR (MAX)   NOT NULL,
    [ShortName]          NVARCHAR (50)    NULL,
    [ProjectNumber]      NVARCHAR (100)   NOT NULL,
    [CountryProgrammeId] UNIQUEIDENTIFIER NOT NULL
);

